===============================================
SETUP AGENT SYSTEM DI HOSTING
===============================================

LANGKAH 1: BUAT DATABASE DI CPANEL
===================================

1. Login ke cPanel hosting Anda
2. Cari menu "MySQL Databases"
3. Buat database baru:
   - Database Name: mikhmon_agents (atau nama lain)
   - Klik "Create Database"
4. Catat nama database lengkap (biasanya: username_mikhmon_agents)

LANGKAH 2: BUAT USER DATABASE
==============================

1. Di halaman yang sama, scroll ke "MySQL Users"
2. Buat user baru:
   - Username: mikhmon_user (atau nama lain)
   - Password: (buat password kuat)
   - Klik "Create User"
3. Catat username lengkap (biasanya: username_mikhmon_user)
4. Catat password yang Anda buat

LANGKAH 3: ASSIGN USER KE DATABASE
===================================

1. Scroll ke "Add User To Database"
2. Pilih user yang baru dibuat
3. Pilih database yang baru dibuat
4. Klik "Add"
5. Centang "ALL PRIVILEGES"
6. Klik "Make Changes"

LANGKAH 4: IMPORT DATABASE
===========================

1. Di cPanel, cari menu "phpMyAdmin"
2. Klik database yang baru dibuat di sidebar kiri
3. Klik tab "Import" di atas
4. Klik "Choose File"
5. Pilih file: mikhmon/database/agent_system.sql
6. Klik "Go"
7. Tunggu sampai selesai
8. Verify: harus ada 8 table:
   - agents
   - agent_prices
   - agent_transactions
   - agent_vouchers
   - agent_topup_requests
   - agent_commissions
   - agent_settings
   - (dan beberapa views)

LANGKAH 5: UPDATE DB_CONFIG.PHP
================================

1. Edit file: mikhmon/include/db_config.php
2. Update kredensial database:

define('DB_HOST', 'localhost'); // biasanya localhost
define('DB_USER', 'username_mikhmon_user'); // <-- GANTI
define('DB_PASS', 'password_anda'); // <-- GANTI
define('DB_NAME', 'username_mikhmon_agents'); // <-- GANTI

Contoh:
define('DB_HOST', 'localhost');
define('DB_USER', 'alijaya_mikhmon');
define('DB_PASS', 'P@ssw0rd123');
define('DB_NAME', 'alijaya_agents');

3. Save file
4. Upload ke hosting (overwrite yang lama)

LANGKAH 6: TEST KONEKSI
========================

1. Akses URL hosting Anda
2. Login ke MikhMon admin
3. Klik menu "Agent Management"
4. Jika muncul halaman (tidak loading), berarti BERHASIL!

===============================================

TROUBLESHOOTING HOSTING:
========================

ERROR: "Access denied for user"
--------------------------------
→ Cek username dan password di db_config.php
→ Pastikan user sudah di-assign ke database
→ Pastikan password benar (case sensitive)

ERROR: "Unknown database"
-------------------------
→ Cek nama database di db_config.php
→ Pastikan database sudah dibuat di cPanel
→ Gunakan nama lengkap (dengan prefix username)

ERROR: "Can't connect to MySQL server"
---------------------------------------
→ Cek DB_HOST di db_config.php
→ Biasanya 'localhost'
→ Beberapa hosting pakai IP khusus
→ Cek di cPanel → MySQL Databases → Host

ERROR: "Table doesn't exist"
-----------------------------
→ Import ulang file agent_system.sql
→ Pastikan import berhasil 100%
→ Cek di phpMyAdmin apakah table ada

ERROR: Menu masih loading
--------------------------
→ Clear browser cache
→ Cek error log di cPanel
→ Enable error display di index.php
→ Cek file permissions (755 untuk folder, 644 untuk file)

===============================================

TIPS HOSTING:
=============

1. BACKUP DATABASE
   - Sebelum import, backup database lama
   - Export via phpMyAdmin
   - Simpan file .sql

2. FILE PERMISSIONS
   - Folder: 755
   - File PHP: 644
   - Jangan pakai 777 (tidak aman)

3. ERROR LOG
   - Cek error log di cPanel
   - File Manager → error_log
   - Atau cPanel → Errors

4. PHP VERSION
   - Pastikan PHP 7.4 atau lebih baru
   - Cek di cPanel → Select PHP Version
   - Atau cPanel → MultiPHP Manager

5. MEMORY LIMIT
   - Jika import gagal, naikkan memory limit
   - Edit .htaccess atau php.ini
   - Atau hubungi support hosting

===============================================

CONTOH KREDENSIAL HOSTING:
==========================

Hosting Shared (cPanel):
------------------------
DB_HOST: localhost
DB_USER: username_dbuser
DB_PASS: password123
DB_NAME: username_dbname

Hosting VPS:
------------
DB_HOST: localhost (atau IP server)
DB_USER: mikhmon_user
DB_PASS: password123
DB_NAME: mikhmon_agents

Cloud Hosting (AWS, DigitalOcean):
-----------------------------------
DB_HOST: db.example.com (atau IP)
DB_USER: admin
DB_PASS: password123
DB_NAME: mikhmon_agents

===============================================

SETELAH SETUP BERHASIL:
=======================

✓ Menu agent tidak loading lagi
✓ Bisa tambah agent baru
✓ Bisa set harga per profile
✓ Bisa topup saldo agent
✓ Agent bisa login & generate voucher

===============================================

BUTUH BANTUAN?
==============

Kirim informasi ini:
1. Nama hosting provider
2. Screenshot error message
3. Screenshot db_config.php (sensor password)
4. Screenshot phpMyAdmin (list table)
5. Screenshot cPanel MySQL Databases

===============================================
